/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : 127.0.0.1:3306
 Source Schema         : shiyan

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 20/09/2022 01:09:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for web_article
-- ----------------------------
DROP TABLE IF EXISTS `web_article`;
CREATE TABLE `web_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `one_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '一级分类id',
  `two_type_id` int(10) NOT NULL DEFAULT '0' COMMENT '二级分类id',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `short_title` varchar(255) NOT NULL DEFAULT '' COMMENT '短标题',
  `img` int(10) NOT NULL DEFAULT '0' COMMENT '封面图',
  `content` text NOT NULL COMMENT '内容',
  `is_banner` varchar(255) NOT NULL COMMENT '是否是banner',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `file_path` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '编辑时间',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='文章表';

-- ----------------------------
-- Records of web_article
-- ----------------------------
BEGIN;
INSERT INTO `web_article` VALUES (1, 2, 10, '领导成员标题', '领导成员标题', 19, '                                                \r\n                                                <p>领导成员标题领导<b style=\"background-color: rgb(255, 255, 0);\">成员标题领导成员标</b>题领导成员标题</p><p>领导成员标题</p><p>领导成员标题</p><p>领导成员标题</p><p><img src=\"\" data-filename=\"u=2240596607,3466641662&fm=26&gp=0.jpg\" style=\"width: 478px;\"><br></p><p>\r\n                                                                                            </p>                                                                                        ', '1', 0, '', '', 1612533510, 1612531776);
INSERT INTO `web_article` VALUES (2, 2, 11, '机构设置文章', '机构设置文章', 20, '<p>机构设置文章机构设置文章机构设置文章</p><p>机构设置文章</p><p>机构设置文章</p><p>机构设置文章</p><p>机构设置文章</p><p><img src=\"\" data-filename=\"u=937542061,2509577545&fm=26&gp=0.jpg\" style=\"width: 474px;\"></p><p><br></p><p>\r\n                                                                                            </p>', '1', 0, '', '', 0, 1612534846);
INSERT INTO `web_article` VALUES (3, 2, 12, '信息公开指南', '信息公开指南', 21, '信息公开指南信息公开指南信息公开指南\r\n                                                                                            ', '1', 0, '', '', 0, 1612534997);
INSERT INTO `web_article` VALUES (4, 3, 18, '1', '1', 0, '111111111', '0', 0, '', '', 0, 1612536706);
INSERT INTO `web_article` VALUES (8, 3, 18, '5', '5', 0, '55555555555', '0', 0, '', '', 0, 1612536773);
INSERT INTO `web_article` VALUES (9, 3, 19, '6', '6', 0, '6666', '0', 0, '', '', 0, 1612538115);
INSERT INTO `web_article` VALUES (10, 3, 20, '7', '7', 0, '7777', '0', 0, '', '', 0, 1612539005);
INSERT INTO `web_article` VALUES (11, 44, 0, '市人社局党员领导干部到包联社区开展春节前走访慰问', '111', 0, '111111\r\n                                                                                            ', '0', 0, '', '', 1614850422, 1612625498);
INSERT INTO `web_article` VALUES (12, 44, 0, '市人社局党员领导干部到包联社区开展春节前走访慰问', '2222', 0, '222222222222\r\n                                                                                            ', '0', 0, '', '', 1614850429, 1612625511);
INSERT INTO `web_article` VALUES (13, 44, 0, '市人社局党员领导干部到包联社区开展春节前走访慰问', '333', 0, '33333333', '0', 0, '', '', 1614850435, 1612625525);
INSERT INTO `web_article` VALUES (14, 47, 0, '常见问题解答1 ', '常见问题1 ', 0, '常见问题1 常见问题1 常见问题1 常见问题1 \r\n                                                                                            ', '0', 0, '', '', 0, 1612627084);
INSERT INTO `web_article` VALUES (15, 47, 0, '常见问题解答2 ', '常见问题2', 0, '常见问题2常见问题2常见问题2常见问题2', '0', 0, '', '', 0, 1612627084);
INSERT INTO `web_article` VALUES (16, 49, 0, '服务大厅大标题1', '服务大厅1', 0, '服务大厅1服务大厅1服务大厅1\r\n                                                                                            ', '0', 0, '', '', 0, 1612627456);
INSERT INTO `web_article` VALUES (17, 50, 0, '通知公告公示大标题', '通知公告公示', 0, '通知公告公示通知公告公示通知公告公示\r\n                                                                                            ', '0', 0, '', '', 0, 1612627617);
INSERT INTO `web_article` VALUES (18, 52, 0, '政府规章长标题1', '政府规章1', 0, '政府规章1政府规章1政府规章1政府规章1政府规章1', '0', 0, '', '', 0, 1612628669);
INSERT INTO `web_article` VALUES (19, 53, 0, '就业失业长标题', '', 0, '就业失业长标题就业失业长标题就业失业长标题\r\n                                                                                            ', '0', 0, '', '', 0, 1612629544);
INSERT INTO `web_article` VALUES (20, 54, 0, '资讯热点长标题', '资讯热点', 0, '<p>\r\n                                                资讯热点资讯热点资讯热点资讯热点资讯热点资讯热点</p><p>资讯热点资讯热点资讯热点</p><p>资讯热点资讯热点资讯热点资讯热点资讯热点资讯热点</p><p>资讯热点资讯热点资讯热点资讯热点资讯热点资讯热点</p><p><img src=\"\" data-filename=\"u=2095392332,1883621763&fm=26&gp=0.jpg\" style=\"width: 413px;\"><br></p><p>\r\n                                                                                                                                        </p>', '0', 0, '', '', 1612682489, 1612629570);
INSERT INTO `web_article` VALUES (21, 55, 0, '文档下载1长标题', '文档下载1', 0, '\r\n                                                \r\n                                                <h1 style=\"text-align: center; \"><b style=\"\"><font color=\"#fff\">这个是富文本的标题</font></b></h1><p>请下载下面文档</p><p><a href=\"http://www.shiyan.com/uploads/file/2021-02-07/16126724652589.docx\" target=\"_blank\"><font color=\"#0000ff\">待整合版.docx</font></a></p>                                                                                        ', '0', 0, '待整合版.docx', 'uploads/file/2021-02-07/16126724652589.docx', 1612674292, 1612672550);
INSERT INTO `web_article` VALUES (22, 3, 18, '2', '', 0, '321', '0', 321, '', '', 0, 1612759440);
INSERT INTO `web_article` VALUES (23, 2, 10, 'test', '', 0, '<p>        范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份</p><p>        范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份</p><p>        范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份范德萨发大神发送大法师打发士大夫撒旦发多少发达上分份<br></p>', '0', 0, '', '', 0, 1612783606);
COMMIT;

-- ----------------------------
-- Table structure for web_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `web_auth_group`;
CREATE TABLE `web_auth_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '分组名',
  `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `show_rules` varchar(500) NOT NULL COMMENT '【仅用于数据回显】用户组拥有的规则id，多个规则 , 隔开',
  `rules` varchar(500) NOT NULL COMMENT '【真实权限】用户组拥有的规则id，多个规则 , 隔开',
  `status` int(10) NOT NULL DEFAULT '1' COMMENT '状态；1：启用，2：禁用',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '编辑时间',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='权限分组表';

-- ----------------------------
-- Records of web_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `web_auth_group` VALUES (1, '默认权限组', '默认权限组', '1,4,6,31,12,8,9', '1,4,6,31,12,8,9,5,2', 2, 1612339585, 0);
COMMIT;

-- ----------------------------
-- Table structure for web_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `web_auth_group_access`;
CREATE TABLE `web_auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='成员授权列表';

-- ----------------------------
-- Records of web_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `web_auth_group_access` VALUES (3, 1);
INSERT INTO `web_auth_group_access` VALUES (3, 2);
COMMIT;

-- ----------------------------
-- Table structure for web_config
-- ----------------------------
DROP TABLE IF EXISTS `web_config`;
CREATE TABLE `web_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '配置标识（使用config函数调用，只能使用英文且不能重复）',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '配置类型；1：字符，2：数字，3：文本，4：数组',
  `group_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置分组',
  `value` text NOT NULL COMMENT '配置值',
  `remark` text NOT NULL COMMENT '配置详细说明',
  `sort` tinyint(3) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='配置表';

-- ----------------------------
-- Records of web_config
-- ----------------------------
BEGIN;
INSERT INTO `web_config` VALUES (1, 'WEB_TITLE', '网站标题', 1, 1, '服务网', '', 0);
INSERT INTO `web_config` VALUES (3, 'WEB_RECORD', '网站备案号', 1, 1, '湘ICP备18012419号', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for web_config_group
-- ----------------------------
DROP TABLE IF EXISTS `web_config_group`;
CREATE TABLE `web_config_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '分组名',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '编辑时间',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='配置分组表';

-- ----------------------------
-- Records of web_config_group
-- ----------------------------
BEGIN;
INSERT INTO `web_config_group` VALUES (1, '基本配置', 0, 0, 1611819179);
INSERT INTO `web_config_group` VALUES (2, '系统配置', 1, 0, 1611821287);
INSERT INTO `web_config_group` VALUES (11, '小程序配置', 2, 0, 1611883235);
COMMIT;

-- ----------------------------
-- Table structure for web_job
-- ----------------------------
DROP TABLE IF EXISTS `web_job`;
CREATE TABLE `web_job` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '姓名',
  `no` varchar(255) NOT NULL DEFAULT '' COMMENT '证书编号',
  `sex` varchar(255) NOT NULL DEFAULT '' COMMENT '性别',
  `province_name` varchar(255) NOT NULL COMMENT '出生地点',
  `ratify_date` date NOT NULL COMMENT '批准日期',
  `number` varchar(255) NOT NULL DEFAULT '' COMMENT '证件号码',
  `job_name` varchar(255) NOT NULL DEFAULT '' COMMENT '专业名称',
  `job_level` varchar(255) NOT NULL DEFAULT '' COMMENT '专业等级',
  `send_company` varchar(255) NOT NULL DEFAULT '' COMMENT '发证单位',
  `qr` varchar(255) NOT NULL DEFAULT '' COMMENT '二维码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='职称表';

-- ----------------------------
-- Records of web_job
-- ----------------------------
BEGIN;
INSERT INTO `web_job` VALUES (1, '陈子强', 'W0662019045872', '男', '浙江省', '2019-03-22', '330326197910195416', '结构', '工程师 ', '武汉市人力资源和社会保障局', '/qr/2021-02-23/16140704691342.png');
INSERT INTO `web_job` VALUES (2, 'test', 'W0662019045873', '男', '天津市', '2021-02-17', '11fdasfdsafdas', '程序员', '工程师', '奥克斯', '/qr/2021-02-23/16140705506279.png');
INSERT INTO `web_job` VALUES (3, 'test2', 'F23V8BGsWMNkug43444', '男', '北京市', '2021-02-25', 'fdsa', '程序员', '工程师', '奥克斯', '/qr/2021-02-23/16140740838909.png');
COMMIT;

-- ----------------------------
-- Table structure for web_menu
-- ----------------------------
DROP TABLE IF EXISTS `web_menu`;
CREATE TABLE `web_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '图标',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单名',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转链接',
  `pid` int(10) NOT NULL DEFAULT '0' COMMENT '父级id',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序，数值越小排序越靠前',
  `level` int(10) NOT NULL DEFAULT '1' COMMENT '1：顶部菜单，2：左侧分组菜单，3：左侧分组子菜单，4：操作菜单：如新增',
  `status` int(10) NOT NULL DEFAULT '1' COMMENT '状态；1：启用，2：禁用',
  `is_show` int(10) NOT NULL DEFAULT '1' COMMENT '1：显示，2：隐藏',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COMMENT='菜单表';

-- ----------------------------
-- Records of web_menu
-- ----------------------------
BEGIN;
INSERT INTO `web_menu` VALUES (1, '', '首页', '/admin/index/index', 0, 0, 1, 1, 1, 1614070817, 0);
INSERT INTO `web_menu` VALUES (2, '', '管理', '/admin/manage/articleList', 0, 1, 1, 1, 1, 1614070817, 0);
INSERT INTO `web_menu` VALUES (3, '', '系统配置', '/admin/system/menuList', 0, 2, 1, 1, 1, 1614070817, 0);
INSERT INTO `web_menu` VALUES (4, 'fa-indent', '首页', '/admin/index/index', 1, 1, 2, 1, 1, 1611796637, 0);
INSERT INTO `web_menu` VALUES (5, 'fa-user-circle-o', 'DEMO', '/admin/manage/userList', 2, 3, 2, 1, 1, 1614070817, 0);
INSERT INTO `web_menu` VALUES (6, '', '列表示例', '/admin/manage/userList', 5, 1, 3, 1, 1, 1612344121, 0);
INSERT INTO `web_menu` VALUES (7, '', '表单示例', '/admin/manage/memberList', 5, 2, 3, 1, 1, 1612344129, 0);
INSERT INTO `web_menu` VALUES (9, '', '轮播图列表', '/admin/manage/bannerList', 8, 3, 3, 1, 1, 1611312269, 0);
INSERT INTO `web_menu` VALUES (10, 'fa-sliders', '配置管理', '/admin/system/configGroupList', 3, 2, 2, 1, 1, 1614070817, 0);
INSERT INTO `web_menu` VALUES (11, 'fa-bars', '菜单管理', '/admin/system/menuList', 3, 1, 2, 1, 1, 1611795908, 0);
INSERT INTO `web_menu` VALUES (12, '', '统计图示例', '/admin/manage/chart', 5, 3, 3, 1, 1, 1612344138, 0);
INSERT INTO `web_menu` VALUES (13, '', '操作菜单', '/admin/system/doMenu', 11, 1, 3, 1, 2, 0, 0);
INSERT INTO `web_menu` VALUES (31, '', '新增用户', '/admin/manage/addUser', 6, 1, 4, 1, 2, 0, 1611740596);
INSERT INTO `web_menu` VALUES (32, '', '新增会员', '/user/manage/addMember', 7, 1, 4, 1, 2, 0, 1611740635);
INSERT INTO `web_menu` VALUES (33, '', '配置分组', '/admin/system/configGroupList', 10, 0, 3, 1, 1, 0, 1611818162);
INSERT INTO `web_menu` VALUES (34, '', '网站配置', '/admin/system/setConfig', 10, 0, 3, 1, 1, 0, 1611818217);
INSERT INTO `web_menu` VALUES (35, '', '新增/编辑 分组', '/admin/system/doConfigGroup', 33, 0, 4, 1, 2, 0, 1611819599);
INSERT INTO `web_menu` VALUES (36, '', '删除分组', '/admin/system/delConfigGroup', 33, 1, 4, 1, 2, 0, 1611819626);
INSERT INTO `web_menu` VALUES (39, '', '编辑配置', '/admin/system/doConfig', 34, 1, 4, 1, 2, 1611881720, 1611823647);
INSERT INTO `web_menu` VALUES (40, '', '删除配置', '/admin/system/delConfig', 34, 2, 4, 1, 2, 0, 1611823675);
INSERT INTO `web_menu` VALUES (43, 'fa-magic', '权限管理', '/admin/system/userList', 3, 3, 2, 1, 2, 1612411502, 1611890913);
INSERT INTO `web_menu` VALUES (44, '', '权限分组列表', '/admin/system/authGroupList', 43, 1, 3, 1, 1, 0, 1611891626);
INSERT INTO `web_menu` VALUES (45, '', '新增/编辑 权限分组', '/admin/system/doAuthGroup', 44, 0, 4, 1, 2, 0, 1611900772);
INSERT INTO `web_menu` VALUES (46, '', '访问授权', '/admin/system/visit', 43, 2, 3, 1, 2, 1612144032, 1611907644);
INSERT INTO `web_menu` VALUES (47, '', '用户授权', '/admin/system/userAuth', 43, 3, 3, 1, 2, 1612144037, 1611908574);
INSERT INTO `web_menu` VALUES (48, '', '解除授权', '/admin/system/relieveAuth', 47, 1, 4, 1, 2, 0, 1612320915);
INSERT INTO `web_menu` VALUES (49, '', '新增授权', '/admin/system/addAuth', 47, 0, 4, 1, 2, 0, 1612321460);
INSERT INTO `web_menu` VALUES (50, '', '删除权限分组', '/admin/system/delAuthGroup', 43, 4, 3, 1, 2, 1612339359, 1612339234);
INSERT INTO `web_menu` VALUES (51, '', '用户信息', '/admin/system/userList', 43, 0, 3, 1, 1, 0, 1612342547);
INSERT INTO `web_menu` VALUES (52, 'fa-list-alt', '文章管理', '/admin/manage/articleList', 2, 1, 2, 1, 1, 1614070817, 1612506256);
INSERT INTO `web_menu` VALUES (53, '', '文章列表', '/admin/manage/articleList', 52, 0, 3, 1, 1, 0, 1612506292);
INSERT INTO `web_menu` VALUES (54, '', '新增/编辑 文章', '/admin/manage/doArticle', 52, 1, 3, 1, 2, 1612506511, 1612506355);
INSERT INTO `web_menu` VALUES (55, '', '删除文章', '/admin/manage/delArticle', 52, 2, 3, 1, 2, 1612506515, 1612506379);
INSERT INTO `web_menu` VALUES (56, 'fa-file-o', '分类管理', '/admin/manage/typeList', 2, 0, 2, 1, 2, 1612696411, 1612508590);
INSERT INTO `web_menu` VALUES (57, '', '分类列表', '/admin/manage/typeList', 56, 0, 3, 1, 1, 0, 1612508611);
INSERT INTO `web_menu` VALUES (58, '', '新增/编辑 分类', '/admin/manage/doType', 56, 0, 3, 1, 2, 0, 1612508640);
INSERT INTO `web_menu` VALUES (59, '', '删除分类', '/admin/manage/delType', 56, 0, 3, 1, 2, 0, 1612508666);
INSERT INTO `web_menu` VALUES (60, 'fa-user-secret', '职称管理', '/admin/manage/jobList', 2, 2, 2, 1, 1, 1614070817, 1612696586);
INSERT INTO `web_menu` VALUES (61, '', '职称列表', '/admin/manage/jobList', 60, 0, 3, 1, 1, 0, 1612696625);
INSERT INTO `web_menu` VALUES (62, '', '新增/编辑 职称', '/admin/manage/doJob', 61, 0, 4, 1, 2, 1612701042, 1612696664);
INSERT INTO `web_menu` VALUES (63, '', '删除职称', '/admin/manage/delJob', 61, 0, 4, 1, 2, 0, 1612696681);
INSERT INTO `web_menu` VALUES (64, '', '证书编号生成规则', '/admin/manage/noRule', 60, 0, 3, 1, 1, 0, 1614070817);
COMMIT;

-- ----------------------------
-- Table structure for web_no_rule
-- ----------------------------
DROP TABLE IF EXISTS `web_no_rule`;
CREATE TABLE `web_no_rule` (
  `id` int(10) NOT NULL DEFAULT '1' COMMENT '固定为1',
  `no_header` varchar(255) NOT NULL DEFAULT '' COMMENT '编号开头',
  `no_length` varchar(255) NOT NULL DEFAULT '' COMMENT '证书长度'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='证书编号生成规则表';

-- ----------------------------
-- Records of web_no_rule
-- ----------------------------
BEGIN;
INSERT INTO `web_no_rule` VALUES (1, 'F23', '16');
COMMIT;

-- ----------------------------
-- Table structure for web_picture
-- ----------------------------
DROP TABLE IF EXISTS `web_picture`;
CREATE TABLE `web_picture` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '图片路径',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='图片表';

-- ----------------------------
-- Records of web_picture
-- ----------------------------
BEGIN;
INSERT INTO `web_picture` VALUES (1, '/uploads/picture/2021-02-05/16125197086816.jpg', 1612519708);
INSERT INTO `web_picture` VALUES (2, '/uploads/picture/2021-02-05/16125198894039.jpg', 1612519889);
INSERT INTO `web_picture` VALUES (3, '/uploads/picture/2021-02-05/16125199662062.jpg', 1612519966);
INSERT INTO `web_picture` VALUES (4, '/uploads/picture/2021-02-05/16125200011909.jpg', 1612520001);
INSERT INTO `web_picture` VALUES (5, '/uploads/picture/2021-02-05/16125200421609.jpg', 1612520042);
INSERT INTO `web_picture` VALUES (6, '/uploads/picture/2021-02-05/16125201003376.jpg', 1612520100);
INSERT INTO `web_picture` VALUES (7, '/uploads/picture/2021-02-05/16125201485411.jpg', 1612520148);
INSERT INTO `web_picture` VALUES (8, '/uploads/picture/2021-02-05/16125201681517.jpg', 1612520168);
INSERT INTO `web_picture` VALUES (9, '/uploads/picture/2021-02-05/16125201933640.jpg', 1612520193);
INSERT INTO `web_picture` VALUES (10, '/uploads/picture/2021-02-05/16125202148123.jpg', 1612520214);
INSERT INTO `web_picture` VALUES (11, '/uploads/picture/2021-02-05/16125210482449.jpg', 1612521048);
INSERT INTO `web_picture` VALUES (12, '/uploads/picture/2021-02-05/16125210717912.jpg', 1612521071);
INSERT INTO `web_picture` VALUES (13, '/uploads/picture/2021-02-05/16125210903711.jpg', 1612521090);
INSERT INTO `web_picture` VALUES (14, '/uploads/picture/2021-02-05/16125215795278.jpg', 1612521579);
INSERT INTO `web_picture` VALUES (15, '/uploads/picture/2021-02-05/16125302692201.jpg', 1612530269);
INSERT INTO `web_picture` VALUES (16, '/uploads/picture/2021-02-05/16125316452825.jpg', 1612531645);
INSERT INTO `web_picture` VALUES (17, '/uploads/picture/2021-02-05/16125317626843.jpg', 1612531762);
INSERT INTO `web_picture` VALUES (18, '/uploads/picture/2021-02-05/16125324189837.jpg', 1612532418);
INSERT INTO `web_picture` VALUES (19, '/uploads/picture/2021-02-05/16125326696524.jpg', 1612532669);
INSERT INTO `web_picture` VALUES (20, '/uploads/picture/2021-02-05/16125348259987.jpg', 1612534825);
INSERT INTO `web_picture` VALUES (21, '/uploads/picture/2021-02-05/16125349958070.jpg', 1612534995);
COMMIT;

-- ----------------------------
-- Table structure for web_province
-- ----------------------------
DROP TABLE IF EXISTS `web_province`;
CREATE TABLE `web_province` (
  `name` varchar(255) NOT NULL COMMENT '地区名称'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of web_province
-- ----------------------------
BEGIN;
INSERT INTO `web_province` VALUES ('北京市');
INSERT INTO `web_province` VALUES ('天津市');
INSERT INTO `web_province` VALUES ('河北省');
INSERT INTO `web_province` VALUES ('山西省');
INSERT INTO `web_province` VALUES ('内蒙古自治区');
INSERT INTO `web_province` VALUES ('辽宁省');
INSERT INTO `web_province` VALUES ('吉林省');
INSERT INTO `web_province` VALUES ('黑龙江省');
INSERT INTO `web_province` VALUES ('上海市');
INSERT INTO `web_province` VALUES ('江苏省');
INSERT INTO `web_province` VALUES ('浙江省');
INSERT INTO `web_province` VALUES ('安徽省');
INSERT INTO `web_province` VALUES ('福建省');
INSERT INTO `web_province` VALUES ('江西省');
INSERT INTO `web_province` VALUES ('山东省');
INSERT INTO `web_province` VALUES ('河南省');
INSERT INTO `web_province` VALUES ('湖北省');
INSERT INTO `web_province` VALUES ('湖南省');
INSERT INTO `web_province` VALUES ('广东省');
INSERT INTO `web_province` VALUES ('广西壮族自治区');
INSERT INTO `web_province` VALUES ('海南省');
INSERT INTO `web_province` VALUES ('重庆市');
INSERT INTO `web_province` VALUES ('四川省');
INSERT INTO `web_province` VALUES ('贵州省');
INSERT INTO `web_province` VALUES ('云南省');
INSERT INTO `web_province` VALUES ('西藏自治区');
INSERT INTO `web_province` VALUES ('陕西省');
INSERT INTO `web_province` VALUES ('甘肃省');
INSERT INTO `web_province` VALUES ('青海省');
INSERT INTO `web_province` VALUES ('宁夏回族自治区');
INSERT INTO `web_province` VALUES ('新疆维吾尔自治区');
INSERT INTO `web_province` VALUES ('香港特别行政区');
INSERT INTO `web_province` VALUES ('澳门特别行政区');
COMMIT;

-- ----------------------------
-- Table structure for web_type
-- ----------------------------
DROP TABLE IF EXISTS `web_type`;
CREATE TABLE `web_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) NOT NULL DEFAULT '0' COMMENT '父级id',
  `name` varchar(255) NOT NULL COMMENT '分类名',
  `is_business` int(10) NOT NULL COMMENT '是否属于业务工作',
  `is_nav` int(10) NOT NULL DEFAULT '0' COMMENT '1：导航分类，2：首页内容分类',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of web_type
-- ----------------------------
BEGIN;
INSERT INTO `web_type` VALUES (1, 0, '首页', 0, 1, 0);
INSERT INTO `web_type` VALUES (2, 0, '信息公开', 0, 1, 0);
INSERT INTO `web_type` VALUES (3, 0, '政策法规', 0, 1, 0);
INSERT INTO `web_type` VALUES (4, 0, '办事大厅', 0, 1, 0);
INSERT INTO `web_type` VALUES (5, 0, '阳光政务', 1, 1, 0);
INSERT INTO `web_type` VALUES (6, 0, '交流互动', 0, 1, 0);
INSERT INTO `web_type` VALUES (7, 0, '业务工作', 0, 1, 0);
INSERT INTO `web_type` VALUES (8, 0, '12333专栏', 0, 1, 0);
INSERT INTO `web_type` VALUES (9, 0, '机关党建', 0, 1, 0);
INSERT INTO `web_type` VALUES (10, 2, '领导成员', 0, 1, 0);
INSERT INTO `web_type` VALUES (11, 2, '机构设置', 0, 1, 0);
INSERT INTO `web_type` VALUES (12, 2, '信息公开指南', 0, 1, 0);
INSERT INTO `web_type` VALUES (13, 2, '信息公开目录', 0, 1, 0);
INSERT INTO `web_type` VALUES (14, 2, '信息公开规定', 0, 1, 0);
INSERT INTO `web_type` VALUES (15, 2, '政务动态', 0, 1, 0);
INSERT INTO `web_type` VALUES (16, 2, '信息公开年度报告', 0, 1, 0);
INSERT INTO `web_type` VALUES (17, 2, '公告公示', 0, 1, 0);
INSERT INTO `web_type` VALUES (18, 3, '政策法规', 0, 1, 0);
INSERT INTO `web_type` VALUES (19, 3, '政策问答', 0, 1, 0);
INSERT INTO `web_type` VALUES (20, 3, '政策解读', 0, 1, 0);
INSERT INTO `web_type` VALUES (21, 4, '办事指南', 0, 1, 0);
INSERT INTO `web_type` VALUES (22, 4, '表格下载', 0, 1, 0);
INSERT INTO `web_type` VALUES (23, 5, '公务员管理', 0, 1, 0);
INSERT INTO `web_type` VALUES (24, 5, '人才工作', 0, 1, 0);
INSERT INTO `web_type` VALUES (25, 5, '人事管理', 0, 1, 0);
INSERT INTO `web_type` VALUES (26, 5, '就业失业', 0, 1, 0);
INSERT INTO `web_type` VALUES (27, 5, '社会保险', 0, 1, 0);
INSERT INTO `web_type` VALUES (28, 5, '工资福利', 0, 1, 0);
INSERT INTO `web_type` VALUES (29, 5, '行政审批', 0, 1, 0);
INSERT INTO `web_type` VALUES (30, 5, '劳动关系', 0, 1, 0);
INSERT INTO `web_type` VALUES (31, 5, '人事考试', 0, 1, 0);
INSERT INTO `web_type` VALUES (32, 6, '局长信箱', 0, 1, 0);
INSERT INTO `web_type` VALUES (33, 6, '监督投诉', 0, 1, 0);
INSERT INTO `web_type` VALUES (34, 6, '网上咨询', 0, 1, 0);
INSERT INTO `web_type` VALUES (35, 6, '业务咨询', 0, 1, 0);
INSERT INTO `web_type` VALUES (36, 6, '在线访谈', 0, 1, 0);
INSERT INTO `web_type` VALUES (44, 0, '最新资讯', 0, 2, 0);
INSERT INTO `web_type` VALUES (45, 0, '领导论文', 0, 2, 0);
INSERT INTO `web_type` VALUES (46, 0, '机关党建', 0, 2, 0);
INSERT INTO `web_type` VALUES (47, 0, '常见问题解答', 0, 2, 0);
INSERT INTO `web_type` VALUES (49, 0, '服务大厅', 0, 2, 0);
INSERT INTO `web_type` VALUES (50, 0, '通知公告公示', 0, 2, 0);
INSERT INTO `web_type` VALUES (51, 0, '业务工作', 0, 2, 0);
INSERT INTO `web_type` VALUES (52, 0, '政府规章', 0, 2, 0);
INSERT INTO `web_type` VALUES (53, 0, '就业失业', 0, 2, 0);
INSERT INTO `web_type` VALUES (54, 0, '咨询热点', 0, 2, 0);
INSERT INTO `web_type` VALUES (55, 0, '表格下载', 0, 2, 0);
INSERT INTO `web_type` VALUES (58, 6, '书记信箱', 0, 2, 0);
COMMIT;

-- ----------------------------
-- Table structure for web_user
-- ----------------------------
DROP TABLE IF EXISTS `web_user`;
CREATE TABLE `web_user` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL DEFAULT '' COMMENT '昵称',
  `account` char(32) NOT NULL DEFAULT '' COMMENT '登录账号',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(50) NOT NULL DEFAULT '' COMMENT '邮箱',
  `mobile` char(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `status` int(10) NOT NULL DEFAULT '1' COMMENT '状态；1：正常；2：禁用',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '编辑时间',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `accountpassword` (`account`,`password`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of web_user
-- ----------------------------
BEGIN;
INSERT INTO `web_user` VALUES (1, 'admin', 'admin', 'MDAwMDAwMDAwMK6Mgq1/qIlk', '', '13121126169', 1, 1610951568, 1222907803);
INSERT INTO `web_user` VALUES (3, 'Dave', 'Dave', 'MDAwMDAwMDAwMK6Mgq1/qIlk', '', '18573148753', 1, 1610951568, 1610951568);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
